About

This repository contains code to visualize employee salary data from the Government of Canada’s Treasury Board, publicly available here. A webpage with outputs and findings can be found here.

The Data

This data is based on self-identification of equity-deserving group and is only available for the core federal public service. In order to obtain the data, the webpage was scraped with the R package rvest. Then, dplyr and tidyr were used to clean it up and plotting was done with: ggplot2, plotly scales, and MetBrewer.

We are including the following groups in Total Asian Population:

  • Chinese
  • Japanese
  • Korean
  • Filipino
  • South Asian/ East Indian
  • Southeast Asian

Non-White West Asian was not included because it was grouped along with North African and Arab. If needed, this group can be added into the data.

The Plots

Total Asian Population

This plot looks at the total count of self-identifying Asian employees.

Year-Over-Year Growth

This plot looks at the year-over-year (YOY) growth of self-identifying Asian employees.

Considering these two plots, we can see that though the YOY is comparable between Asian and non-Asian employees, the pre-existing disproportionality between the groups continue to persist.

Breakdown by departments

Top 10 departments

This is a more focused plot which looks at the top 10 deparments with the highest Asian population.

All departments

This is a really busy plot but it shows the breakdown of Asian and non-Asian employees by count.

Future endeavours

Moving forward, these data can be further broken down looking more into the departments/agencies, looking at the classfication, salary wages, etc.